/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 13/09/2025 15:01:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_repair_progress
-- ----------------------------
DROP TABLE IF EXISTS `sc_repair_progress`;
CREATE TABLE `sc_repair_progress` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '进度ID',
  `order_id` bigint(20) NOT NULL COMMENT '工单ID',
  `order_no` varchar(50) NOT NULL COMMENT '工单号',
  `progress_type` tinyint(4) NOT NULL COMMENT '进度类型：1-受理，2-分配，3-开始维修，4-完成，5-取消',
  `progress_title` varchar(100) DEFAULT NULL COMMENT '进度标题',
  `progress_content` text COMMENT '进度内容',
  `progress_time` datetime DEFAULT NULL COMMENT '进度发生时间',
  `operator_id` bigint(20) DEFAULT NULL COMMENT '操作人ID',
  `repairman_id` bigint(20) DEFAULT NULL COMMENT '维修人员ID',
  `repairman_name` varchar(50) DEFAULT NULL COMMENT '维修人员姓名',
  `remark` text COMMENT '备注信息',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1-正常，0-已删除',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序字段',
  `operator_name` varchar(50) DEFAULT NULL COMMENT '操作人姓名',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_order_id` (`order_id`),
  KEY `idx_order_no` (`order_no`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COMMENT='维修工单进度记录表';

-- ----------------------------
-- Records of sc_repair_progress
-- ----------------------------
BEGIN;
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (1, 4, 'RO20250714150146334859', 2, NULL, '工单已受理', '2025-07-16 11:39:12', 1, NULL, NULL, NULL, 1, 0, '系统', '2025-07-16 11:39:12');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (2, 4, 'RO20250714150146334859', 3, NULL, '开始维修', '2025-07-16 11:39:25', 24, NULL, NULL, NULL, 1, 0, '系统', '2025-07-16 11:39:25');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (3, 3, 'RO202501003', 2, NULL, '工单已受理', '2025-07-17 03:01:39', 6, NULL, NULL, NULL, 1, 0, '系统', '2025-07-17 03:01:39');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (4, 3, 'RO202501003', 3, NULL, '开始维修', '2025-07-17 03:10:09', 24, NULL, NULL, NULL, 1, 0, '系统', '2025-07-17 03:10:09');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (6, 2, 'RO202501002', 2, '工单受理', '工单已受理，分配维修师傅：维修人员', '2025-07-17 12:16:14', 1, 1, '维修人员', NULL, 1, 2, '系统用户', '2025-07-17 12:16:14');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (8, 2, 'RO202501002', 3, '开始维修', '开始维修', '2025-07-17 12:16:37', 1, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 12:16:37');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (10, 2, 'RO202501002', 4, '维修完成', '工单已完成，备注：维修结果：搞不定问题，我就搞定发出问题的人，业主已被我解决！', '2025-07-17 12:17:35', 1, NULL, NULL, NULL, 1, 6, '系统用户', '2025-07-17 12:17:35');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (12, 1, 'RO202501001', 5, '工单取消', '工单已取消，备注：取消原因：用户取消', '2025-07-17 12:17:59', 1, NULL, NULL, NULL, 1, 2, '系统用户', '2025-07-17 12:17:59');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (13, 5, 'RO20250717122104866840', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 12:21:04', 1, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 12:21:04');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (15, 5, 'RO20250717122104866840', 2, '工单受理', '工单已受理，分配维修师傅：维修人员', '2025-07-17 12:21:21', 1, 1, '维修人员', NULL, 1, 3, '系统用户', '2025-07-17 12:21:21');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (17, 5, 'RO20250717122104866840', 3, '开始维修', '开始维修', '2025-07-17 12:21:23', 1, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 12:21:23');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (19, 5, 'RO20250717122104866840', 4, '维修完成', '工单已完成，备注：维修结果：修理完毕，重新换了个新空调！', '2025-07-17 12:29:39', 1, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 12:29:39');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (20, 6, 'RO20250717123041492791', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 12:30:42', 1, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 12:30:42');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (22, 6, 'RO20250717123041492791', 2, '工单受理', '工单已受理，分配维修师傅：维修人员', '2025-07-17 12:31:04', 1, 1, '维修人员', NULL, 1, 3, '系统用户', '2025-07-17 12:31:04');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (24, 6, 'RO20250717123041492791', 3, '开始维修', '开始维修', '2025-07-17 13:14:28', 1, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 13:14:28');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (26, 6, 'RO20250717123041492791', 4, '维修完成', '工单已完成，备注：维修结果：RO20250717123041492791 ok', '2025-07-17 13:14:57', 1, NULL, NULL, NULL, 1, 7, '系统用户', '2025-07-17 13:14:57');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (28, 3, 'RO202501003', 4, '维修完成', '工单已完成，备注：维修结果：RO202501003', '2025-07-17 13:16:22', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:16:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (29, 7, 'RO20250717131734531849', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 13:17:35', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 13:17:35');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (31, 7, 'RO20250717131734531849', 2, '工单受理', '工单已受理，分配维修师傅：测试用户2-已编辑', '2025-07-17 13:17:47', 9, 6, '测试用户2-已编辑', NULL, 1, 3, '系统用户', '2025-07-17 13:17:47');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (33, 7, 'RO20250717131734531849', 3, '开始维修', '开始维修', '2025-07-17 13:18:13', 9, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 13:18:13');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (35, 7, 'RO20250717131734531849', 4, '维修完成', '工单已完成，备注：维修结果：RO20250717131734531849', '2025-07-17 13:18:24', 9, NULL, NULL, NULL, 1, 7, '系统用户', '2025-07-17 13:18:24');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (37, 4, 'RO20250714150146334859', 4, '维修完成', '工单已完成，备注：维修结果：RO20250714150146334859', '2025-07-17 13:25:17', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:25:17');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (38, 8, 'RO20250717133859258057', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 13:38:59', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 13:38:59');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (40, 8, 'RO20250717133859258057', 2, '工单受理', '工单已受理，分配维修师傅：测试用户3-已编辑', '2025-07-17 13:39:23', 9, 7, '测试用户3-已编辑', NULL, 1, 3, '系统用户', '2025-07-17 13:39:23');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (41, 8, 'RO20250717133859258057', 2, '分配备注', '18329188884', '2025-07-17 13:39:24', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:39:24');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (42, 8, 'RO20250717133859258057', 2, '状态更新', '工单状态已更新，备注：18329188884', '2025-07-17 13:39:24', 9, NULL, NULL, NULL, 1, 5, '系统用户', '2025-07-17 13:39:24');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (44, 8, 'RO20250717133859258057', 3, '开始维修', '开始维修', '2025-07-17 13:40:59', 9, NULL, NULL, NULL, 1, 7, '系统用户', '2025-07-17 13:40:59');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (46, 8, 'RO20250717133859258057', 4, '维修完成', '工单已完成', '2025-07-17 13:43:22', 9, 7, '测试用户3-已编辑', NULL, 1, 9, '系统用户', '2025-07-17 13:43:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (47, 8, 'RO20250717133859258057', 4, '维修完成', '工单已完成，备注：维修结果：已经维修完成！电梯可以正常运行了！；备注：已经维修完成', '2025-07-17 13:43:22', 9, NULL, NULL, NULL, 1, 10, '系统用户', '2025-07-17 13:43:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (48, 9, 'RO20250717135629403071', 1, '工单创建', '工单已创建，等待受理', '2025-07-17 13:56:30', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-17 13:56:30');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (50, 9, 'RO20250717135629403071', 2, '工单受理', '工单已受理，分配维修师傅：智慧物业管理员，备注：电梯坏了', '2025-07-17 13:56:41', 9, 9, '智慧物业管理员', NULL, 1, 3, '系统用户', '2025-07-17 13:56:41');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (51, 9, 'RO20250717135629403071', 2, '状态更新', '工单状态已更新，备注：电梯坏了', '2025-07-17 13:56:41', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 13:56:41');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (52, 9, 'RO20250717135629403071', 3, '开始维修', '开始维修', '2025-07-17 14:01:08', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-17 14:01:08');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (53, 9, 'RO20250717135629403071', 4, '维修完成', '工单已完成，维修结果：-- ========================================\n-- 删除维修工单触发器SQL脚本\n-- 作者: Wu.Liang\n-- 日期: 2025-01-30\n-- 说明: 删除维修工单相关的数据库触发器，避免重复创建进度记录\n-- ========================================\n\n-- 1. 删除维修工单状态变更触发器\nDROP TRIGGER IF EXISTS `tr_repair_order_status_change`;\n\n-- 2. 删除维修工单创建进度触发器（如果存在）\nDROP TRIGGER IF EXISTS `tr_repair_order_create_progress`;\n\n-- 3. 验证触发器已删除\nSELECT \n    TRIGGER_NAME,\n    EVENT_MANIPULATION,\n    EVENT_OBJECT_TABLE\nFROM information_schema.TRIGGERS \nWHERE EVENT_OBJECT_SCHEMA = DATABASE() \nA，备注：-- ========================================\n-- 删除维修工单触发器SQL脚本\n-- 作者: Wu.Liang\n-- 日期: 2025-01-30\n-- 说明: 删除维修工单相关的数据库触发器，避免重复创建进度记录\n-- ========================================\n\n-- 1. 删除维修工单状态变更触发器\nDROP ', '2025-07-17 14:01:20', 9, 9, '智慧物业管理员', NULL, 1, 5, '系统用户', '2025-07-17 14:01:20');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (54, 10, 'RO20250728114013143934', 1, '工单创建', '工单已创建，等待受理', '2025-07-28 11:40:14', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-07-28 11:40:14');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (55, 10, 'RO20250728114013143934', 2, '工单受理', '工单已受理，分配维修师傅：gufeiya4，备注：水电维修', '2025-07-28 11:40:48', 9, 30, 'gufeiya4', NULL, 1, 2, '系统用户', '2025-07-28 11:40:48');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (56, 10, 'RO20250728114013143934', 2, '状态更新', '工单状态已更新，备注：水电维修', '2025-07-28 11:40:48', 9, NULL, NULL, NULL, 1, 3, '系统用户', '2025-07-28 11:40:48');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (57, 10, 'RO20250728114013143934', 3, '开始维修', '开始维修', '2025-07-28 11:45:36', 9, NULL, NULL, NULL, 1, 4, '系统用户', '2025-07-28 11:45:36');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (58, 11, 'RO20250808150906755493', 1, '工单创建', '工单已创建，等待受理', '2025-08-08 15:09:06', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-08 15:09:07');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (59, 12, 'RO20250811171820713731', 1, '工单创建', '工单已创建，等待受理', '2025-08-11 17:18:21', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-11 17:18:21');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (60, 13, 'RO20250811180332592308', 1, '工单创建', '工单已创建，等待受理', '2025-08-11 18:03:32', 9, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-11 18:03:32');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (61, 14, 'RO20250812135933299141', 1, '工单创建', '工单已创建，等待受理', '2025-08-12 13:59:33', 32, NULL, NULL, NULL, 1, 1, '系统用户', '2025-08-12 13:59:33');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (62, 14, 'RO20250812135933299141', 2, '工单受理', '工单已受理，分配维修师傅：小呱呱', '2025-08-12 14:00:30', 32, 32, '小呱呱', NULL, 1, 2, '系统用户', '2025-08-12 14:00:30');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (63, 20, 'RO20250829155733802220', 3, '开始维修', '开始维修', '2025-08-29 16:29:15', 42, NULL, NULL, NULL, 1, 1, '毛哥', '2025-08-29 16:29:15');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (64, 19, 'RO20250829155409960456', 2, '工单受理', '工单已受理，分配维修师傅：毛哥，备注：111', '2025-08-29 16:29:46', 42, 42, '毛哥', NULL, 1, 1, '毛哥', '2025-08-29 16:29:47');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (65, 19, 'RO20250829155409960456', 2, '状态更新', '工单状态已更新，备注：111', '2025-08-29 16:29:47', 42, NULL, NULL, NULL, 1, 2, '毛哥', '2025-08-29 16:29:47');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (66, 19, 'RO20250829155409960456', 3, '开始维修', '开始维修', '2025-08-29 16:30:10', 42, NULL, NULL, NULL, 1, 3, '毛哥', '2025-08-29 16:30:10');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (67, 18, 'RO20250829155257538918', 2, '工单受理', '工单已受理，分配维修师傅：毛哥，备注：2', '2025-08-29 16:35:14', 42, 42, '毛哥', NULL, 1, 1, '毛哥', '2025-08-29 16:35:14');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (68, 18, 'RO20250829155257538918', 2, '状态更新', '工单状态已更新，备注：2', '2025-08-29 16:35:14', 42, NULL, NULL, NULL, 1, 2, '毛哥', '2025-08-29 16:35:14');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (69, 18, 'RO20250829155257538918', 3, '开始维修', '开始维修', '2025-08-29 16:43:16', 42, NULL, NULL, NULL, 1, 3, '毛哥', '2025-08-29 16:43:16');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (70, 15, 'RO20250829144940759033', 2, '工单受理', '工单已受理，分配维修师傅：毛哥，备注：1', '2025-08-29 16:43:33', 42, 42, '毛哥', NULL, 1, 1, '毛哥', '2025-08-29 16:43:33');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (71, 15, 'RO20250829144940759033', 2, '状态更新', '工单状态已更新，备注：1', '2025-08-29 16:43:33', 42, NULL, NULL, NULL, 1, 2, '毛哥', '2025-08-29 16:43:33');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (72, 20, 'RO20250829155733802220', 4, '维修完成', '工单已完成，维修结果：完美搞定！完美搞定！', '2025-08-29 16:46:02', 42, 42, '毛哥', NULL, 1, 2, '毛哥', '2025-08-29 16:46:02');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (73, 15, 'RO20250829144940759033', 3, '开始维修', '开始维修', '2025-08-29 17:05:20', 42, NULL, NULL, NULL, 1, 3, '毛哥', '2025-08-29 17:05:20');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (74, 16, 'RO20250829152509523035', 5, '工单取消', '工单已取消，备注：取消原因：用户主动取消', '2025-08-29 17:27:52', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-29 17:27:52');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (75, 21, 'RO20250829174237134884', 1, '工单创建', '工单已创建，等待受理', '2025-08-29 17:42:38', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-29 17:42:38');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (76, 22, 'RO20250829174325917136', 1, '工单创建', '工单已创建，等待受理', '2025-08-29 17:43:26', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-29 17:43:26');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (77, 23, 'RO20250829175511671873', 1, '工单创建', '工单已创建，等待受理', '2025-08-29 17:55:11', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-29 17:55:11');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (78, 21, 'RO20250829174237134884', 5, '工单取消', '工单已取消，备注：取消原因：用户主动取消', '2025-08-29 17:57:49', 45, NULL, NULL, NULL, 1, 2, '瓜哥', '2025-08-29 17:57:49');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (79, 23, 'RO20250829175511671873', 5, '工单取消', '工单已取消，备注：取消原因：用户主动取消', '2025-08-29 17:58:15', 45, NULL, NULL, NULL, 1, 2, '瓜哥', '2025-08-29 17:58:15');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (80, 24, 'RO20250829181058309483', 1, '工单创建', '工单已创建，等待受理', '2025-08-29 18:10:58', 42, NULL, NULL, NULL, 1, 1, '毛哥', '2025-08-29 18:10:58');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (81, 25, 'RO20250830003916051306', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 00:39:17', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-30 00:39:17');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (82, 26, 'RO20250830004038812338', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 00:40:38', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-30 00:40:39');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (83, 27, 'RO20250830014435748372', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 01:44:36', 42, NULL, NULL, NULL, 1, 1, '毛哥', '2025-08-30 01:44:36');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (84, 28, 'RO20250830015159028144', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 01:52:00', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-30 01:52:00');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (85, 29, 'RO20250830020155484868', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 02:01:55', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-30 02:01:55');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (86, 30, 'RO20250830020728134490', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 02:07:29', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-30 02:07:29');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (87, 31, 'RO20250830021403745930', 1, '工单创建', '工单已创建，等待受理', '2025-08-30 02:14:03', 45, NULL, NULL, NULL, 1, 1, '瓜哥', '2025-08-30 02:14:03');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (88, 31, 'RO20250830021403745930', 2, '工单受理', '工单已受理，分配维修师傅：毛哥，备注：浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', '2025-08-30 23:03:20', 42, 42, '毛哥', NULL, 1, 2, '毛哥', '2025-08-30 23:03:20');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (89, 31, 'RO20250830021403745930', 2, '状态更新', '工单状态已更新，备注：浙江省杭州市临平区塘栖镇乐苑小区14栋1单元401号', '2025-08-30 23:03:21', 42, NULL, NULL, NULL, 1, 3, '毛哥', '2025-08-30 23:03:21');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (90, 28, 'RO20250830015159028144', 2, '工单受理', '工单已受理，分配维修师傅：毛哥，备注：11111', '2025-08-30 23:04:03', 42, 42, '毛哥', NULL, 1, 2, '毛哥', '2025-08-30 23:04:03');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (91, 28, 'RO20250830015159028144', 2, '状态更新', '工单状态已更新，备注：11111', '2025-08-30 23:04:04', 42, NULL, NULL, NULL, 1, 3, '毛哥', '2025-08-30 23:04:04');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (92, 32, 'RO20250902201516665736', 1, '工单创建', '工单已创建，等待受理', '2025-09-02 20:15:16', 31, NULL, NULL, NULL, 1, 1, '小毛毛', '2025-09-02 20:15:17');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (93, 32, 'RO20250902201516665736', 5, '工单取消', '工单已取消，备注：取消原因：我报错了，Sorry！', '2025-09-02 20:16:07', 31, NULL, NULL, NULL, 1, 2, '小毛毛', '2025-09-02 20:16:07');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (94, 33, 'RO20250904155430492403', 1, '工单创建', '工单已创建，等待受理', '2025-09-04 15:54:31', 31, NULL, NULL, NULL, 1, 1, '小毛毛', '2025-09-04 15:54:32');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (95, 28, 'RO20250830015159028144', 3, '开始维修', '开始维修', '2025-09-04 18:25:54', 42, NULL, NULL, NULL, 1, 4, '毛哥', '2025-09-04 18:25:54');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (96, 30, 'RO20250830020728134490', 2, '工单受理', '工单已受理，分配维修师傅：毛哥，备注：2', '2025-09-10 16:12:21', 42, 42, '毛哥', NULL, 1, 2, '毛哥', '2025-09-10 16:12:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (97, 30, 'RO20250830020728134490', 2, '状态更新', '工单状态已更新，备注：2', '2025-09-10 16:12:22', 42, NULL, NULL, NULL, 1, 3, '毛哥', '2025-09-10 16:12:22');
INSERT INTO `sc_repair_progress` (`id`, `order_id`, `order_no`, `progress_type`, `progress_title`, `progress_content`, `progress_time`, `operator_id`, `repairman_id`, `repairman_name`, `remark`, `status`, `sort_order`, `operator_name`, `create_time`) VALUES (98, 34, 'RO20250911104641134892', 1, '工单创建', '工单已创建，等待受理', '2025-09-11 10:46:41', 31, NULL, NULL, NULL, 1, 1, '小毛毛', '2025-09-11 10:46:42');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
